<?
REQUIRE("../../protect/connect.php");
$query="UPDATE sdville SET ville_niv='4' WHERE ville_population > 250000 AND ville_niv!='4'";
$resultat=mysql_query($query);

$query="UPDATE sdville SET ville_niv='3',ville_case4='' WHERE (ville_population BETWEEN 100000 AND 249999) AND ville_niv!='3'";
$resultat=mysql_query($query);

$query="UPDATE sdville SET ville_niv='2',ville_case3='',ville_case4=''  WHERE (ville_population BETWEEN 10000 AND 99999) AND ville_niv!='2'";
$resultat=mysql_query($query);

$query="UPDATE sdville SET ville_niv='1', ville_case2='',ville_case3='',ville_case4='' WHERE ville_population < 9999 AND ville_niv!='1'";
$resultat=mysql_query($query);






?>



